Search Results

Search found 32757 results on 1311 pages for 'database cursor'.

Page 218/1311 | < Previous Page | 214 215 216 217 218 219 220 221 222 223 224 225  | Next Page >

• How to use an external file for database configuration in EJB environment

  - by bosnic

  I need to have a file for database configuration outside of EAR file of my EJB application. Even if I define a datasource and call it via JNDI, I still have some properties that I want to change, like hibernate.dialect or hibernate.show_sql, for example. I tried using: <property name="hibernate.ejb.cfgfile" value="some-file.xml" /> and it works fine when some-file.xml is in jar file, but how to call it from another location. I tried file:/// but didn´t work. thanks

  Read the article

• How to set cursor at the end in a TEXTAREA? (by not using jQuery)

  - by Brian Hawk

  Is there a way to set the cursor at the end in a TEXTAREA tag? I'm using Firefox 3.6 and I don't need it to work in IE or Chrome. JavaScript is ok but it seems all the related answers in here use onfocus() event, which seems to be useless because when user clicks on anywhere within textarea, Firefox sets cursor position to there. I have a long text to display in a textarea so that it displays the last portion (making it easier to add something at the end).

  Read the article

• Database connection error Crystal Reports 2008

  - by developer

  Hi All, When I try to pull a report in Crystal Reports 2008, it gives me error that says Physical database not found in the Report Viewer. As I am new to Crystal reports, could you please explain me how to solve this error

  Read the article

• node.js database

  - by Justin

  I'm looking for a database to pair with a node.js app. I'm assuming a json/nosql db would be preferable to a relational db [I can do without any json/sql impedence mismatch]. Considering couchdb mongodb redis Anyone have any views / war stories re compatiability/deployability of the above with node.js ? Any clear favourites ?

  Read the article

• Database maintenance, big binary table optimization

  - by jgemedina

  Hi i have a huge database, around 1 TB in size, most of the space is consumed by a table which stores images, the tables has right now almost 800k rows. server response time has increased, i would like to know which techniques should i use or you recomend, partitioning? o how to reorganize the table every row is accessed by the image id column, and it has its clustered index by that column, and every two days i reorganize the index and every 7 days i rebuild it, but it seems not to be working any suggestions?

  Read the article

• Query.fetch(limit=2000) only moves cursor forward by 1000 entities?

  - by Liron

  Let's say I have 2500 MyModel entities in my datastore, and I run this code: query = MyModel.all() first_batch = query.fetch(2000) len(first_batch) # 2000 next_query = MyModel.all().with_cursor(query.cursor()) next_batch = next_query.fetch(2000) What do you think len(next_batch) is? 500, right? Nope - it's 1500. Apparently the query cursor never moves forward by more than 1000, even when the query itself returns more than 1000 entities. Should I do something different or is it just an App Engine bug?

  Read the article

• Creating application using rails 2.3.5 and cassandra database

  - by Joshi

  hi all, Pls guide me how to create rails application using rails 2.3.5 and cassandra database as rails 2.3.5 supports mysql, sqllite etc. I typed in the command prompt like this $ rails -d cassandra myapp Databases supported for preconfiguration are: mysql, oracle, postgresql, sqlite2, sqlite3, frontbase, ibm_db So pls help me in this regard

  Read the article

• Sample Employee SQL Server database with data

  - by Tom

  Hi I need some sample SQL Server Employee database with data such as id, surname, name, age, adress etc. It must be quite big, I search with google, but I don't find any good sample. Can any body help ?

  Read the article

• Load a .bin file in SQL server 2005 Express database in vc++ application

  - by Feroz Khan

  I would like to put a binary file in varbinary(MAX) column using _RecordsetPtr in a vc++ application.I am sure that lot of people have done this before. But I am new to database programming. Help is urgently needed ...Thanks in advance.

  Read the article

• Creating a shared HSQLDB database

  - by Robert Munteanu

  In-process HSQLDB database are not expected to be opened by others, even for file-based storage. The documentation hints that this is possible: Server Modes, Advanced Topics, but I've not yet found a URL for how to activate this behaviour. Did anyone do this so they can share how to?

  Read the article

• How to test if a MS SQL 2008 database can serve 200 concurent users

  - by sh00

  I have a MS SQL 2008 database in 3NF. I must check if the db can support many concurent users. Which is the best method ? [Is there any free tool to do this ?] Thank you very much.

  Read the article

• View all foreign key constraints for entire MySQL database

  - by Scott Wolf

  I have a large database with over 150 tables that I've recently been handed. I'm just wondering if there is an easy way to view all foreign key constraints for the entire DB instead of on a per-table basis.

  Read the article

• Force DATABASE ALTER ignoring errors

  - by Felipe Fiali

  As the name says, force the alter database to alter its collation ignoring the error message that I get from functions or calculated columns that compare data. Is there a way to do so? Like IGNORE_ERRORS or something like that? Thanks a lot!

  Read the article

• How to find out the username and password for mysql database

  - by Abhishek

  Hi, I ve forgot what i set as username and password for mysql database. How could I be able to find it out.I am using wamp server. I am a newbie in mysql and its time to get started for my first project.Please help.

  Read the article

• java swing frame excellent for resultset from database

  - by merin

  sir, l want to display resultset in jframe.i get output last record in the database displayed. Lam intrested to place next button,back button in the frame.when i was click in the back button previosly viewed record is displayed and vice-versa.i don't know it will be possible.plz help me

  Read the article

• The Best Way to shred XML data into SQL Server database columns

  - by eddiegroves

  What is the best way to shred XML data into various database columns? So far I have mainly been using the nodes and value functions like so: INSERT INTO some_table (column1, column2, column3) SELECT Rows.n.value('(@column1)[1]', 'varchar(20)'), Rows.n.value('(@column2)[1]', 'nvarchar(100)'), Rows.n.value('(@column3)[1]', 'int'), FROM @xml.nodes('//Rows') Rows(n) However I find that this is getting very slow for even moderate size xml data.

  Read the article

• Connecting to an existing database in Netbeans

  - by nix

  I'm working in NetBeans 6.8 and I'm trying to create new connection using MySQL to an existing database. Does the .mdb file need to be in a specific location? It tells me that it cannot establish the connection.

  Read the article

• 32bit to 64bit sql server 2008 database conversion

  - by Eric

  We are in the process of moving databases from older 32 bit hardware running sql 2005 to newer hardware with sql 2008 64 bit. My question is if the database is automatically converted to 64bit after it is reattached on the new server or if it is running in 32bit mode on a 64bit instance. Is there a way to tell?

  Read the article

• Easy way to view images in a database

  - by Vaccano

  I have a web service that I just coded up that drops an image (png) into my SQL Server 2008 database as a varbinary. Is there a easy tool out there that can let me see that image? I could code up a client, but I would rather just use a tool if one exists.

  Read the article

• Can netezza database handle procedures?

  - by san6086

  Hi I am having Netezza Database. I am querying the tables through DB visualiser. Since my table creation involves complex, I am interested to use procedures but I am unable to write it in DBvisualiser. I am confused whether the problem is with the tool that I use or in Netezza? Please advice

  Read the article

• Restoring a utf8 encoded database to an iso 1 server - effect on strings

  - by Alan

  We are doing a migration of our Sybase database that has a utf8 encoding to a server with iso 1 encoding. We are just using char and Varchar for our strings. Will doing backup and restore not truncate any strings? I was thinking that Char and Varchar are just single byte characters.

  Read the article

• [RAILS] Howto to download a file from a http and save it into database

  - by Chris

  Hi, i would like to create a Rails controller that download a serie of jpg files from the web and directly write them into database as binary (I am not trying to do an upload form) Any clue on the way to do that ? Thank you

  Read the article

• How to count the advertisement hits and stores it in database

  - by Paul

  We put our website advertisement in 2 other websites. We need to count the hits we are getting form those advertisement and like to store it in my database. Please give me an idea to do that.

  Read the article

• Modelling database entites using text only

  - by Jaimal Chohan

  Back in the day, there was a standard that I was taught a standard for modelling database entities using text only, I can't remember the name of the standard but it looked somehing like TableName, Key, Column Anybody know what that form was called?

  Read the article

• Save RTF data in My Sql database

  - by Rajesh Rolen- DotNet Developer

  Please tell me how to save and show Richtextbox's data in database and retrive it in saved format and which datatype should be used to save that data. i am using vb.net and MY SQL

  Read the article

< Previous Page | 214 215 216 217 218 219 220 221 222 223 224 225  | Next Page >