1. JavaDB: Is it possible to change auto-increment offset on existing table? stackoverflow.comIs it possible to change the auto-increment offset on a pre-existing table with JavaDB? I'm having a problem where inserting new records usually (but not always) fails with an error ... |
2. Jython zxJDBC cursor.tables() always returns None stackoverflow.comI am using Jython 2.2.1 and MySQL Connector/J 5.1 to access a MySQL database. I would like to use zxJDBC's cursor.tables() method to retrieve a list of tables in that ... |
3. What is the best way of relating relational database tables into Java classes? stackoverflow.comI wonder if anyone can advise me here; I have an application which has classes like this: Code: |
4. Database tables for entries of another table? stackoverflow.comI'm designing a new revision of my Java application (using an embedded H2 database) around a redesign of the way I'll be handling my data. Here's how I have it ... |
5. Java DB Table inheritance? stackoverflow.comIs it possible to do Table Inheritance in Java DB? We have a complex code model that uses inheritance and would also benefit from DB inheritance. Is it possible? It doesn't seem ... |
6. Archiving Database Tables using Java stackoverflow.comMy application demands archiving database tables between sybase and db2 and vice-a-versa and within(db2 to db2 and sybase to sybase) using java. I am trying to understand the best strategies around in ... |
7. java class that simulates a simple database table stackoverflow.comI have a collection of heterogenous data that I pull from a database table mtable. Then, for every unique value uv in column A, I compute a function of (SELECT ... |
8. How to implement Auto_Increment per User, on the same table? stackoverflow.comI would like to have multiple users that share the same tables in the database, but have one auto_increment value per user. I will use an embedded database, JavaDB and as ... |
9. Check if table exists stackoverflow.comI have a desktop application with a database embedded in it. When I execute my program I need to check that specific table exists, or create it if not. Given a Connection ... |
10. Database Tables from POJOs stackoverflow.comIs there any way or any utility to generate hibernate mapping files or directly the database tables from POJOs. I cannot manually insert hibernate annotations since these POJOs are generated dynamically ... |
11. designing database tables using JDBC stackoverflow.comI am creating a users table using JDBC and mysql, each user has a permissions list that comprises Integer values. I am wondering if I should use an array for storing these ... |
12. Fast way to replicate a huge database table using java stackoverflow.com[BACKGROUND] We are currently trying to solve a performance problem. Which is searching for data and presenting it in a paginated way takes about 2-3 minutes. Upon further investigation (and after several ... |
13. Application Development: Should I check for a primary-key on a table or assume it should be there? stackoverflow.comWhen building an application and you are using a table that has a primary key, should you check to see if the table has a primary key or does not have ... |
14. how to get table structre of a database in java? stackoverflow.comhow to get table structre of a database in java? |
15. Database Schema in NetBeans doesn't show any table from my database stackoverflow.comI created new EJB module in NetBeans and I would like to create new Database Schema for my Access database. I created database connection jdbc:odbc:bankaRacun (bankaRacun is name of my database). ... |
16. What database tables does Apache Shiro require? stackoverflow.comI want to use Apache Shiro and MySQL for my Realm. What tables and fields does Shiro need to work? |
17. Are there tools that trace from a database table to java classes? stackoverflow.comThere are many tools that trace dependency between java classes like Lattix, But, Are there tools that trace from a database table to java classes ?(Ideally, create CRUD table automatically) |
18. Finding out when a line has been modified in a H2 database table stackoverflow.comLet's imagine I have two processes A and B performing transactions on a H2 database table T. Process A performs CRUD (Create, Read, Update, Delete) on T. Process B wants to know when ... |
19. Loading a Database Table to Memory to Use stackoverflow.comIn a search application, I need to keep track of the files and their locations. Currently am using a database table for this, but since I have to connect to the ... |
20. jaas, authenticate application users on a database table stackoverflow.comI want to know the simplest way to authenticate an application user on a database table using jaas. |
21. How to export and save tables to .csv from access database in java stackoverflow.comI am trying to export a lot of large tables from a MS Access db with java using the jdbc:odbc bridge. I wanted to save these tables to a csv file ... |
22. Moving H2 Database Files with Linked Tables stackoverflow.comI'm creating two H2 database files, and creating a link between them. I then move them to an embedded system. However, after the move the link has broken. ... |
23. Tables not created on deployment of Java EE Application stackoverflow.comI am running into the simple scenario that I started to create a Java EE App with EJB's. As I changed the structure of some of the EJB's I thought it easiest ... |
24. should i save a db table in a hash map to speed up my program stackoverflow.comI have a polling loop that accesses devices, some of the devices are linked together and as such when one of the linked devices is polled its state must be copied ... |
25. load table in Java program stackoverflow.comI have a table with 25 rows and 3-4 columns. I want to use this table once to read all data from it and store it in Java program. Since I ... |
26. ormlite with persistent h2 db - new tables not get persisted stackoverflow.comWhen I am creating a new H2 database via ORMLite the database file get created but after I close my application, all the data that it stored in the database is ... |
27. Check physical existence of files referenced in DB table stackoverflow.comWe have one rather large table containing documents info together with filepaths pointing to files on file system. After couple of years we noticed that we have files on the disk which ... |
28. Drop TAble if exist and then create table stackoverflow.comi am creating java application using ms access database. i have to create table "student" if not exit and if exist then drop table first then make table student. i have writing code ... |
29. JDBC: Get table list calling method getTables of DatabaseMetadata with advanced table pattern stackoverflow.comI want to call getTables method of DatabaseMetaData and get all tables which names are not starting with "KB". How can I do this? Thanks |
30. Easy way to dump a table's contents to a ASCII formatted table string? stackoverflow.comI am debuging some database code on the Java Platform and it would be convenient to dump the contents of a database table at various points to a log file. Is ... |
31. Creating a "Java DB" database and associated tables in main checking to see if they exist? stackoverflow.comI'm creating an applicaation on Netbeans 7! I'd like my application to have a little code in main so that it can create a Java DB connection checking to see ... |
32. Entity class from the database table stackoverflow.comI am trying to create an entity class from the database table. However, when I click 'Next' it goes to the screen where I suppose to select a schema, but selection combo-box is ... |
33. Quartz JDBCJobStore implementation referencing the user accounts in the main application's Java DB table? stackoverflow.comI'm planning on using Quartz JDBCJobStore task scheduler! I read the tutorials but I still can't tell how I would be able to use this in conjunction with my embedded ... |
34. Using Java schemacrawler, why is it scanning every table in my database? stackoverflow.comUsing Java schemacrawler, why is it scanning every table in my database? Shouldn't it just be scanning the database I specified on the command line: -database=openfire ... |
35. How to access Clarion Tables from Java stackoverflow.comI have this client with this system coded in |
36. CRUD java db for >1 table forums.netbeans.org |
37. Java DB table problems forums.netbeans.orgPosted: Tue Jul 21, 2009 2:49 pm Post subject: Java DB table problems Hi, I am trying to setup a Java database application and am having trouble with ... |
38. Updateing Entity classes affter adding colums to DB table forums.netbeans.orgI am working on a database application, and have been for the past two weeks. Now I need to add more columns into a table. How do I update the entity ... |
39. Java DB - Autonumber + Desktop Database Application Wizard not detecting tables forums.netbeans.orgHi, does anyone know if there is an autonumber function for a key index field with JAVA DB. I've tried creating it with Netbeans, but there is no option. Will I ... |
40. database application setup doesn't recognize tables in access database forums.netbeans.orgI have a access database connected to the IDE through the jdbc-odbc and i can edit the database through the IDE no problem. But when I go to setup a java ... |
41. "Connected database doesn't contain any tables" when it does forums.netbeans.orgHello, I am trying to follow the netbeans tutorial Building a Java Desktop Database Application at http://netbeans.org/kb/docs/java/gui-db.html. When I get to the step where I select the database I created in ... |
42. Reseed JavaDB table forums.netbeans.orgHi, I am new to JavaD and I have managed to create and link a few tables. I have deleted all records from my tables entered during debugging. However I cannot ... |
43. Desktop Application With JDBC - Database does not contain any tables! forums.netbeans.orgPosted: Wed Aug 11, 2010 12:27 pm Post subject: Desktop Application With JDBC - Database does not contain any tables! Hi, I have been trying to use a ... |
44. tables not shown in database forums.netbeans.orghi guys here's the problem when i tried to connect to sql server 2008 first it showed tcp/ip is blocked i configured the tcp/ip port now it says connection successful. But when i tried to bind my Jtable with my database. It showed the database query that was stored but then it didn't showed any database tables. -- Regards: Virender Moudgil ... |
45. connected database does not contain any table! Pls. help... forums.netbeans.orgi'm doing a poject in java and i'm using netbeans IDE. I'm still a newbie in this IDE, so i tried the tutorial in netbeans... I followed every step but there's one problem in database table, it always says "connected database does not contain any table", i'm really confuse about it. I'm really sure there is a table but every time ... |
46. Remote Derby/java db tables aren't visible forums.netbeans.orgI'm using NetBeans IDE 6.9.1 and I have the same issue except that I am using the correct schema... I created tables in derby using NetBeans and my java program cannot connect to the database even though all of the connection information is correct (I checked this by using ij). I then tried to view my tables in the correct schema ... |
47. Displaying a table from my database using database explore tutorial. forums.netbeans.orgIn the tutorial it display the table and the related columns only I want to display the whole table ( columns and rows). I changed the createSceneFromConnection to this but it gave me error.any help?? private void createSceneFromConnection(Connection jdbcConnection) throws SQLException { ArrayList< ArrayList> tables = new ArrayList< ArrayList>(); DatabaseMetaData databaseMetaData = jdbcConnection.getMetaData(); String[] names = {"TABLE"}; ResultSet resultSet = databaseMetaData.getTables(null, ... |
48. Question about QUARTZ 1.8.4 - new database table structure forums.terracotta.orgHi, I have post this topic in the General forum before I notice there is a Quartz forum for my specific question:) Below is the problem I have encountered: I'm upgrading my QUARTZ from 1.5.2 to 1.8.4, and I notice that in the new release some database tables have been changed. For example, table QRTZ_TRIGGERS has a new field "PRIORITY" added. ... |
49. How to Implement Quartz JDBC Tables our WEB Application forums.terracotta.orgAm new to this topic, now i am implements this, please guide me. am creating the quartz JDBC job store tables in my database, but how to implement to this tables. actually am sending the sms job scheduling for using cron trigger, but i dont know correct logic, please any one send me some example code. |
50. Show Table from the database coderanch.com |
51. Java Program to listen DB tables coderanch.com |
52. File instead of Database table coderanch.comSure it's possible, you just have to write the file out in a way that the application knows how to pull from. Not sure how efficient that is, but it's definitely doable. Maybe instead you could create a holder object(s) that keeps the data from the database and use that for access and manipulation, and when you're done write it back ... |
53. How to re-sort the HTML table without requery the database? coderanch.comUsual task: user query the database ,get the resultset. Results are showed in form of HTML table. Now if user want to sort the table based on another field/column, I have to query the database again. Because it takes long time to query the database. I am wondering if there's a way so that I don't have to requery the database ... |
54. CREATE TABLE coderanch.com |
55. How do we store Object in table? coderanch.com |
56. How do we store objects in database table? coderanch.comHi All How do we store and retrieve refernces of objects in a column of a database table,I mean how to store that reference for that object?i headr about serialization?is that we serialize the object to a file and store the name of that file as String in that column and in case we need to deal with that object we ... |
57. Renaming a table coderanch.com |
58. handling "table not found" !!!!! coderanch.com |
59. tables coderanch.comhi, I am not clear about this concept. 30 students have access to the same database (oracle), with different userid and password. We create our own tables. If two of us create a table using the same name, what happens? it is overlapped? How to differ these tables with the same name in the system? Thanks |
60. table list coderanch.comhi, i want to print the list of all tables in a database. i went thru the API DatabaseMetaData.getTables() but am not able to use it bcoz i didnt quite clearly understand the parameters it takes. could anyone gimme a detailed explanation for this, if possible with an example for a database vendor like sybase,db2 or oracle. thanx in advance, shanks. ... |
61. Number of tables in a database coderanch.com |
62. full table scans coderanch.comHi, I have a query which joins 5 tables. All of these tables are really huge. They all have primary key indexes and foreign key indexes. I'm trying to optimize this query for best performance time. I'm using SQL+ Explain Plan to understand how the optimizer executes the query. My sample query is: SELECT TABLE1.COL1,TABLE2.COL2,TABLE3.COL3,TABLE4.COL4,TABLE5.COL5 FROM TABLE1,TABLE2,TABLE3,TABLE4,TABLE5 WHERE TABLE1.COL1 LIKE ? ... |
63. Database with Tables within Tables coderanch.comIs it possible to design a database with tables within tables? For instance: The Big Moose Saloon can be one table consisting of all the forums which each can be one table consisting of all the queries which in turn each can be a table consisting of all the replies. So in summation it looks like this: BigMooseSalon--->Individual Forums---->Individual Queries--->Replies. So ... |
64. Check if a table exists in a database coderanch.com |
65. What is the easiest way to dump a Table into text file? coderanch.com |
66. move tables from one computer to another? coderanch.comHere is the fast and easy way - and probably dangerous too. go to the data directory under mySQL and open the file with the name of the database you are working with, there are three files for each table in the database. Copy the three files from the database folder of one mySQL install to the same place on the ... |
67. My tables are not working any more please help.. coderanch.com |
68. problem with 2 tables in jdbc coderanch.com |
69. How do you find out if a table exists (via JDBC) coderanch.com |
70. How to write to new table? coderanch.comHi Jamie and the other friends, I'm posting my code and shows I'm reading submittedDate from table bug and I have to write it to new table exactly like bug table just submittedDate it's column type is Date(the old one submittedDate was varchar(20)) Could you please help me how can I implement this part (I mean write in new table?) Time ... |
71. Got error 127 from table handler!!! coderanch.com |
72. Backup table? coderanch.com |
73. create table.. which method? coderanch.com |
74. Checking the table already present or not coderanch.com |
75. JDBC Metadata - constructing CREATE of existing table.. coderanch.comI've looked at the FAQs; they state that attachments are not supported. Furthermore, I don't have a place on the web where I can place the file now. So, here's the code for copying and pasting: /** * Implements an immutable |
76. ErrorCode 1311 Cannot open any more tables coderanch.comHi, I'm working with a Microsoft - ODBC Paradox Driver on NT 4 and always get the ErrorCode 1311 Cannot open any more tables. Another time, I get the error message ErrorCode :-5016 sqlException: [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (9482) I made the connection a singleton as well as all classes wrapping data from the db, so ... |
77. Creating Tables coderanch.com |
78. Tables reflection with JDBC coderanch.comThanks to all! Actually the getMethods() method worked but it was requireing a catalog as parameter. So, first I should get a list of catalog by means of getCatalogs() method, and then pass the catalog name I am interested in to the getTables() method. I tried and it worked. Thanks to everybody anyway(I changed my nick name as suggested by the ... |
79. how to test if table exists coderanch.com |
80. Size of table coderanch.com |
81. How to handle a function returning a Table coderanch.com |
82. [Help] Store database table in ArrayList for lookup coderanch.com |
83. DBF Alter Table coderanch.com |
84. Newbie: How to implement to tables with same structure coderanch.com |
85. Tool to convert table definition to java file coderanch.com |
86. Getting all the constraints on a table. coderanch.comHi, Thanks Tina and Simon for ur replies.. Tina,I m aware of the methods u mentioned. Right now I am using the getExportedKeys() and it retrns me a ResultSet of constraint-names and table-names. Sadly there seems to be nothing like this for getting all the constraints. Simon,I m writing a wierd application wherein i m required to delete some tables based ... |
87. How to display all the results of a Table? coderanch.comHello; I have a problem displaying all the results of a Table from my database. My purpose is to display all the results of the table to My given JTextFields. for example : Statement statement1 = connect.createStatement(); String query1 = "SELECT FROM Lastname"; ResultSet rs1 = statement1.executeQuery(query1); rs1.next(); // here's the problem. I don't know how to get all the results ... |
88. table coderanch.comsay there are two table License, Item license has column (lic_name, lic_no, create_date) Item has column(lic_no, item_description) lic_no join 2 table i want to write a file which contain license and Item according to the license i.e. license A Item I Item II license B Item III Item X license C Item IV I have 1 access to DB for getting ... |
89. creating table coderanch.comI'm just learning Java, through a college course. I have been given an assignment to create two tables and populate them with information. I have spent a litte time searching the API hoping for some help but I didn't really know where to start looking. What I need to know first is how to create the table. I know to use ... |
90. need to create object of table coderanch.com |
91. Please help me in creation of tables coderanch.comthanks , but my problem is that, one Dept table and Emp table, there is primary key called Dept_Id which determine the employees in Emp table. 1)how to create these tables using SQL. i.e supposein oracle. 2)And from my servlet application, how can I write SQL statement that fetch the employees of that Dept_Id. |
92. Table merge coderanch.comHello, I have 2 tables that has the same fields.One table is for "free" session and the other table is for "pay" session. The fields are: memberid(autoincrement), starttime (type = datetime), endtime(type = endtime)...I want to merge both of them into a new table called just "session". I know how to just merge those 2 table ..but i don't know how ... |
93. Virtual Tables and the Like coderanch.comHi, I'm working on a project that lets the user effectively add a column of an integer or varchar to a table in any SQL 92 complaint database anytime throughout the life of the project. Then I want to run a query against data that is entered into this table. We had a consultant visit who recommended against modelling the project ... |
94. tjdo tables coderanch.com |
95. TABLE type as IN / OUT in a Stored Procedure coderanch.com |
96. Check existence of table coderanch.comChinmay, Bill mentioned he is using a stored procedure. So he is probably locked into Oracle anyway (stored procs tend to be db specific.) I think the SQL query would be more efficient because it only needs to return one item rather than the list of tables. This could make a difference if there are a lot of tables. |
97. Problem With Creating Table coderanch.comHi, I tried to create a table. This table has seventeen fields. My create table syntax gets too long and I was only able to specify 5 fields at the mysql prompt in the DOS window (DOS does not accept a command beyond certain length). How do I put the rest 12 fields in the table I just created? mysql>CREATE TABLE ... |
98. describing the table!!!... coderanch.comThere are a couple of ways of doing this. One is to use the DatabaseMetaData and the other is to use the ResultSetMetaData. Both methods require a database connection, but the first method doesn't require you to run a query. To use the DatabaseMetaData, here's an example (for Oracle): ResultSet rs; ResultSet rrss; DatabaseMetaData dbmd; Connection conn = ...; // However ... |
99. Table backup - programmatically using JDBC coderanch.com |
100. File instead of Database table coderanch.comSure it's possible, you just have to write the file out in a way that the application knows how to pull from. Not sure how efficient that is, but it's definitely doable. Maybe instead you could create a holder object(s) that keeps the data from the database and use that for access and manipulation, and when you're done write it back ... |