| Thread | Last Post | Replies |
|
| Difference between Statement and preparedStatement (for SQL databases) ? | 18 Oct 2004 17:13 GMT | 14 |
Sometimes I can see pure Statement declaration for accessing SQL databases others use preparedStatements. What is the difference? Ken
|
| Database Design Problem with Hibernate Primary Key and Foreign Key | 18 Oct 2004 09:15 GMT | 3 |
hi, I am a newbie to Hibernate. It seems to me that Hibernate does not allow you to declare both id and composite-id in .hbm.xml mapping. That was why i have a triple primary key in my ENROLLED table as
|
| Opposite of ResultSetMetaData.getColumnName() ?? Is not: putColumnName() | 17 Oct 2004 14:21 GMT | 5 |
As well known I can retrieve the column names by a java code similar to the one below. But how do I put the column names into the database which I retrieve later? There is no function like putColumnName() ResultSetMetaData rsmd = rs.getMetaData();
|
| Inner Join / Indexes Hell | 16 Oct 2004 22:48 GMT | 3 |
Oh I have a nasty query which runs incredibly slowly. I am running MySQL 4.0.20-standard. Thus, in trying to expedite the query, I am trying to set indexes in my tables. My query requires four inner joins, as follows :
|
| Unable to load JdbcOdbc library | 15 Oct 2004 21:36 GMT | 5 |
I am trying to connect to an Informix database on a stand-alone Solaris server. The database only exposes ODBC for external connections, not JDBC. On a PC I set up a system DSN for the database under ODBC, then using
|
| help creating datasource | 14 Oct 2004 20:03 GMT | 2 |
I have made several web apps using struts in Websphere 5.0. For each one I copied a template app having everything I need. We have some batch processing which needs to be done, and instead of using struts I want to make a single standalone class for one of the jobs. The database is ...
|
| Detecting if a table in a database already exists ? | 14 Oct 2004 07:34 GMT | 14 |
Sorry for this newbie question: How do I find out from a java source if a table in a database already exists? I cannot believe that I have to execute a SELECT statement and if there is an exception I know that the table does not exist. But this is a really inconvenient solution.
|
| How can i pass an object data(2 D) through network for a server client environment | 13 Oct 2004 20:42 GMT | 1 |
i need to pass a 2 dimen: object to aa client from server such that this object data contains a clients account logs..my project is network banking software ..plz help me..i am again stucked.. i hv designed server client suchthat they communicate wth string
|
| Java on iSeries: setBinaryStream problem | 13 Oct 2004 16:52 GMT | 4 |
I have got a problem inserting data of a file (both, binary and text) into a blob column. It is created with "Data BLOB(2G)" in the sql statement (so the name of the column is obviously 'Data'). I use a PreparedStatement with the method setBinaryStream. And as far as i can ...
|
| Oracle JDBC BLOB (big size) | 12 Oct 2004 05:24 GMT | 1 |
Hi, is it possible to insert a Blob via JDBC2 ( not oracle native )? I'm using oracle 8, thin driver with jdk 1.3. I have 5 MB data. How can I do this?
|
| Java running MS-SQL job? | 11 Oct 2004 18:42 GMT | 2 |
Is there a way in Java to run an MS-SQL saved job? I have a saved job called test, I can run the following in the Query Analyzer and it runs fine: SQL CODE
|
| how to link Microsoft Access database to JTable .... | 09 Oct 2004 16:40 GMT | 2 |
i am stucked at a point such that i m getting errors when i try to link database to a JTable component in Java.. What i neeed is a solution to link database and JTable so that i can display the contents in database in a table..pls help me...My project
|
| Hibernate Configuration: NoClassDefFoundError | 08 Oct 2004 22:20 GMT | 1 |
I'm trying to get Hibernate 2.1 to work on Tomcat/Apache on Windows. I'm going through chapter 1 of the docs and hitting some trouble. I've made some modifications to the code to try to isolate it: http://eugeneciurana.com/pastebin/pastebin.php?show=3277
|
| sql "where column in (val1,val2,val3)" PreparedStatement question/problem | 08 Oct 2004 19:32 GMT | 6 |
Hello, I have run into this issue a few times and had to work around it with a kludge. When i use the following sql, I don't know how to use a prepared statement to set the parm:
|
| best way to store the results of a query? | 08 Oct 2004 15:41 GMT | 3 |
I was wondering what the common ways to store the results of a JDBC query were. I have recently migrated from Perl, and am used to storing the results in a hash. Is there a similar data structure that can easily handle the results of the query. I have tried HashMap, but cant
|