|
More site info...
Java Database Connectivity (JDBC)
| Forum profile
|
|
Forum profile page for Java Database Connectivity (JDBC)
on http://www.sun.com.
This report page is the aggregated overview from a single forum: Java Database Connectivity (JDBC)
, located on the Message Board at http://www.sun.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Java Database Connectivity (JDBC)
" on the Message Board at http://www.sun.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Java Database Connectivity (JDBC)
:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
50
|
206
|
594
|
|
Post:
|
137
|
554
|
1,655
|
|
|
Java Database Connectivity (JDBC)
Posting activity graph:
|
Top authors during last week:
user's latest post:
Java-Firebird SQL
Published (2009-12-23 17:25:00)
If the database is growing based on historical type records where the older records are subject to far fewer queries then there are database design strategies that can be used to deal with it. And they are better applied sooner than later.
user's latest post:
Java-Firebird SQL
Published (2009-12-23 08:01:00)
But is there any way to transfer the data I need to Java objects and then execute the SQL off of that? Yes. Is the solution I'm thinking about practical? No. If your queries are slow, tune your database and/or queries.
user's latest post:
Oracle encoding
Published (2009-12-23 05:11:00)
Yea to be honest I don't really know. just thought it'd be nice but may just scrap it and stick it in as bytes. Thanks for all the help guys
user's latest post:
Oracle encoding
Published (2009-12-22 03:33:00)
agehoops wrote: Hey thanks for the response but i think I may have sorted it I found another algorithm for the hashing of the password which uses bit shifting and generates a standard string of characters that are all alpha-numeric and forced to use UTF-8 which is fine for the database as it thinks it is plain text and it seems to be working But almost certainly it is not secure. Has the algorithm you are using been the subject of security...
user's latest post:
need help i messed up my code
Published (2009-12-21 02:14:00)
ok thank's for the help im just really new about Tablemodel that's why i cant answer it im still learning i have a lot of different books too but sometimes i dont have the time since im not a programmer im familiar with hardware but im trying to learn java programming so i hope maybe someday i could become a java dev thank's for the help really help me a lot of trouble since this is not the only problem i have with my project
user's latest post:
problem connecting with...
Published (2009-12-22 11:49:00)
Well, whether it tells you or not, they are still thrown. :^) Are you sure you are not eating an exception anywhere? That having been said, explicitly surrounding it with try-catch should show what is happening. - Saish
user's latest post:
problem connecting with...
Published (2009-12-22 18:05:00)
OMG how simple can this get? I used your suggestion of adding the catch around the offending method. Turns out it was being thrown because the mysql jar could not be found (but for some reason I was not catching it.) This happened because I removed mysql as a jar and added it back as a library. Remember - it ran fine in the IDE, so it was getting the library from the IDE, but for some reason, the ant build did not add the library to the...
user's latest post:
jdbc derby connectivity
Published (2009-12-22 20:01:00)
Thanks for your comments whenever i execute the mentioned command i get following error what could be the problem . I m using window environment. C:\>java -cp .;D:\Program Files\glassfish-v2\javadb\lib\derby.jar; Exception in thread "main" java.lang.NoClassDefFoundError: Files\glassfish-v2\ja vadb\lib\derby/jar;
user's latest post:
DB2 vs MySQL
Published (2009-12-19 16:32:00)
Hello! Just my 2 cents: I've used batch updates/inserts on CallableStatements under MySL and have not had performance issues. Maybe the issue is in the SQL and we could help more if you posted the code of your batch...
|
|
|
|
Latest active threads on Java Database Connectivity (JDBC)
::
Started 1 week, 4 days ago (2009-12-18 10:12:00)
by jschell
Print the stack trace.
You should be using prepared statements.
As a guess the SQL that you are passing doesn't match the table. Using explicit column names in your insert can prevent problems about assumptions about ordering in column tables.
Started 6 days, 2 hours ago (2009-12-23 08:01:00)
by dcminter
But is there any way to transfer the data I need to Java objects and then execute the SQL off of that?
Yes.
Is the solution I'm thinking about practical?
No.
If your queries are slow, tune your database and/or queries.
Started 5 days, 17 hours ago (2009-12-23 17:00:00)
by jschell
This has nothing to do with JDBC. The MS Access ODBC driver (nothing to do with java) does whatever it wants.
Solutions
1. Leave it as is
2. Try the single java only driver out there, which requires that you buy it, to see if it works differently. It might not do it differently.
3. Use a different database.
4. Don't use a user/password.
Started 5 months, 1 week ago (2009-07-22 05:38:00)
by Tolls
API.
From the above, for setFetchSize():
"Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for ResultSet objects genrated by this Statement."
ie, this is for setting the number of result it retrieves from the database when all the rows currently retrieved by next() have been read. It ...
Started 5 days, 17 hours ago (2009-12-23 16:53:00)
by jschell
ellias2007 wrote:
Hi every Body,
First i am using Apple Mac OS 10.5 OS,
in order to connect from My JAVA Program to My Mysql DataBases, i open the SystemPreferences Panel and click the Mysql icon (Under the Title : Other) and Get the Botton "Start Mysql Server"
That has nothing to do with Java (the language) nor JDBC.
when i click this Botton to start Mysql work, it asks me about...
Started 6 days, 16 hours ago (2009-12-22 18:17:00)
by jschell
When you say "null" you mean that the following is printing a zero?
(int)rs.getString(2).charAt(0)
I would re-write that as the following just to be sure.
(int)(rs.getString(2).charAt(0))
But regardless what is the exact datatype of the profile_url column in the table?
Started 1 week ago (2009-12-22 02:51:00)
by dcminter
Could anyone help?
Not without a bit more detail. How are you storing the content, how are you retrieving the content, how are you comparing the stored and original strings, etc.
(Edit: Oh, sorry, you did specify the DB).
Edited by: dcminter on 22-Dec-2009 10:51
Started 1 week, 1 day ago (2009-12-21 05:33:00)
by markwagoner
You have to tell the DriverManager about the driver before trying to connect. Look at either Class.forName or DriverManager.registerDriver in the tutorials.
|
|
Hot threads for last week on Java Database Connectivity (JDBC)
::
Started 1 week, 1 day ago (2009-12-21 08:03:00)
by Saish
If it runs in NetBeans but not standalone, then it is likely a classpath problem (that or NetBeans is supplying a JAR that you do not have standalone).
- Saish
Started 1 week ago (2009-12-22 02:51:00)
by dcminter
Could anyone help?
Not without a bit more detail. How are you storing the content, how are you retrieving the content, how are you comparing the stored and original strings, etc.
(Edit: Oh, sorry, you did specify the DB).
Edited by: dcminter on 22-Dec-2009 10:51
Started 1 week, 1 day ago (2009-12-20 23:24:00)
by sabre150
In row.add(rs.getString(i));
addColumn( metadata.getColumnName(i));
every time you add a row of data you add a new set of columns! Add them once only before you add the data.
Started 1 week, 1 day ago (2009-12-21 05:33:00)
by markwagoner
You have to tell the DriverManager about the driver before trying to connect. Look at either Class.forName or DriverManager.registerDriver in the tutorials.
Started 1 week ago (2009-12-22 02:52:00)
by dcminter
If an exception is thrown no string is returned. Fix that.
Started 6 days, 16 hours ago (2009-12-22 18:17:00)
by jschell
When you say "null" you mean that the following is printing a zero?
(int)rs.getString(2).charAt(0)
I would re-write that as the following just to be sure.
(int)(rs.getString(2).charAt(0))
But regardless what is the exact datatype of the profile_url column in the table?
Started 6 days, 2 hours ago (2009-12-23 08:01:00)
by dcminter
But is there any way to transfer the data I need to Java objects and then execute the SQL off of that?
Yes.
Is the solution I'm thinking about practical?
No.
If your queries are slow, tune your database and/or queries.
Started 1 week ago (2009-12-21 11:15:00)
by jschell
Started 1 week ago (2009-12-22 05:59:00)
by Saish
That is not nearly enough information to go on. What portion of the code is failing? (Not a page of code, do some analysis and post relevant portions). Be sure to use the 'code' button or tags when posting your code. What is the underlying table structure? Most programs loop. And obviously you have a statement and a connection or you would not have gotten the stack trace below.
- ...
Started 1 week ago (2009-12-21 11:14:00)
by jschell
Post code, at least an example to demonstrate how you are closing everything.
Are you using the class SystemErrStream? If not then perhaps it has nothing to do with your code. The driver is allowed to do whatever it wants as long as it meets the API definition.
|
|
Size: 309 bytes
