Java JDBC Connection with Derby Database
Required skills: Database Administration, Java
Simple : Java, JDBC connection with Derby Database. To retrieve the Information (already stored) in the derby database using JDBC Connection.
Requirements
- A java source code that connects and retrieve information from tables in the Derby Database using JDBC Connection.
- The Java source code will retrieve the information from the derby database
- The java source code will retrieve a String Object stored in a Column in a Table inside the database
- The retrieval information of the URI object from Database uses five table
- Table 1 will provide a Category ID. Retrieve the Catergory_ID from Table 1.
- Use Table 1’s retrieved Category ID and get REGISTRATION_ID from Table 2.
- Use Table 2’s REGISTRATION_ID to get Table 3’s URI. The URI is a String Object
- The URI object will be like http://localhost:8080/server/repository?name=EXT.MYEXTRACT2&version=1.0.0&type=com.ibm.nex.ois.runtime.productplatform.distributed&request=com.ibm.nex.model.oim.distributed.ExtractRequest
type=com.ibm.nex.ois.runtime.productplatform.distributed"
Retrieve the name value from the URI String object. The retrieve name in Table 3 will be EXT.MYEXTRACT2
Retrieve the version value from the URI String object. The retrieve name in Table 3 will be 1.0.0
For example
Version 1.0.0
Name EXT.MYEXTRACT2
After retrieving the version as single object. Break the version number from 1.0.0 into each separate variable. Break the version digit at period so it will result into three distinct characters 1 0 0 . The split of the version will be on period ‘ . ’that will separate each three digit in the version.
Table 4
Find the content_ID from Table 4 that have Name = "EXT.MYEXTRACT2" , Version Major = 1 Version Minor = 0 Version Path = 0 as retrieved from Table 4
Return the CONTENT_ID that is in the same row of the VERSION_MAJOR = 1 VERSION_MINOR = 0 , VERSION_PATCH = 0 and NAME EXT.MYEXTRACT2
For example the query will return CONTENT_ID 3441d37a-7aef-4936-b58d-fa24948d28da
Table 5
Retrieve the BLOCK from which corresponds to the CONTENT_ID retrieved from Table 4.
If there are multiple entry of the content_id in the Table 5 then retrieve all the BLOCK corresponding to the CONTENT_ID (retrieved from Table 4)
In the case of multiple CONTENT_ID . Join all the block into a single string object. Follow the sequence in joining (starting from 0 , 1 , 2 , 3 ). (Please feel free to ask the questions if required more clarification)
The query should return the BLOCK is above example org.apache.derby.client.am.Blob@394e394e
Convert the Blob "org.apache.derby.client.am.Blob@394e394e" retrieved from Table 5 into String object.
The String object will be an XML Document
Extract the first name next to the pattern "<request xsi:type="distributed:ExtractRequest" name=" in the XML document
Please refer to attached XML document.
Retrieved XML Document from Table 5
<xmi:XMI xmi:version="2.0">
<svc:DistributedServiceRequest name="EXT.MYEXTRACT2" productPlatform="com.ibm.nex.ois.runtime.productplatform.distributed" type=
"com.ibm.nex.model.oim.distributed.ExtractRequest" overrideGroups="/1 /2" overwrite="false">
<request xsi:type="distributed:ExtractRequest" name="EXT.MYEXTRACT2" accessDefinitionName=" " extractFileName= " ">
<eAnnotations source="UDP">
<details key="ibm.optim.isCommandLineRequest" value="true"/>
</eAnnotations>
<pointAndShootState/>
More information will be provided on awarding the project. I have very clear instructions from my side
Please feel free to contact directly, if anyone is interested. Since it is a small project, I will be able to pay only 100 USD.
Requirements
- A java source code that connects and retrieve information from tables in the Derby Database using JDBC Connection.
- The Java source code will retrieve the information from the derby database
- The java source code will retrieve a String Object stored in a Column in a Table inside the database
- The retrieval information of the URI object from Database uses five table
- Table 1 will provide a Category ID. Retrieve the Catergory_ID from Table 1.
- Use Table 1’s retrieved Category ID and get REGISTRATION_ID from Table 2.
- Use Table 2’s REGISTRATION_ID to get Table 3’s URI. The URI is a String Object
- The URI object will be like http://localhost:8080/server/repository?name=EXT.MYEXTRACT2&version=1.0.0&type=com.ibm.nex.ois.runtime.productplatform.distributed&request=com.ibm.nex.model.oim.distributed.ExtractRequest
type=com.ibm.nex.ois.runtime.productplatform.distributed"
Retrieve the name value from the URI String object. The retrieve name in Table 3 will be EXT.MYEXTRACT2
Retrieve the version value from the URI String object. The retrieve name in Table 3 will be 1.0.0
For example
Version 1.0.0
Name EXT.MYEXTRACT2
After retrieving the version as single object. Break the version number from 1.0.0 into each separate variable. Break the version digit at period so it will result into three distinct characters 1 0 0 . The split of the version will be on period ‘ . ’that will separate each three digit in the version.
Table 4
Find the content_ID from Table 4 that have Name = "EXT.MYEXTRACT2" , Version Major = 1 Version Minor = 0 Version Path = 0 as retrieved from Table 4
Return the CONTENT_ID that is in the same row of the VERSION_MAJOR = 1 VERSION_MINOR = 0 , VERSION_PATCH = 0 and NAME EXT.MYEXTRACT2
For example the query will return CONTENT_ID 3441d37a-7aef-4936-b58d-fa24948d28da
Table 5
Retrieve the BLOCK from which corresponds to the CONTENT_ID retrieved from Table 4.
If there are multiple entry of the content_id in the Table 5 then retrieve all the BLOCK corresponding to the CONTENT_ID (retrieved from Table 4)
In the case of multiple CONTENT_ID . Join all the block into a single string object. Follow the sequence in joining (starting from 0 , 1 , 2 , 3 ). (Please feel free to ask the questions if required more clarification)
The query should return the BLOCK is above example org.apache.derby.client.am.Blob@394e394e
Convert the Blob "org.apache.derby.client.am.Blob@394e394e" retrieved from Table 5 into String object.
The String object will be an XML Document
Extract the first name next to the pattern "<request xsi:type="distributed:ExtractRequest" name=" in the XML document
Please refer to attached XML document.
Retrieved XML Document from Table 5
<xmi:XMI xmi:version="2.0">
<svc:DistributedServiceRequest name="EXT.MYEXTRACT2" productPlatform="com.ibm.nex.ois.runtime.productplatform.distributed" type=
"com.ibm.nex.model.oim.distributed.ExtractRequest" overrideGroups="/1 /2" overwrite="false">
<request xsi:type="distributed:ExtractRequest" name="EXT.MYEXTRACT2" accessDefinitionName=" " extractFileName= " ">
<eAnnotations source="UDP">
<details key="ibm.optim.isCommandLineRequest" value="true"/>
</eAnnotations>
<pointAndShootState/>
More information will be provided on awarding the project. I have very clear instructions from my side
Please feel free to contact directly, if anyone is interested. Since it is a small project, I will be able to pay only 100 USD.
Posted In:Java |
Related projects:
Java, JDBC connection with Derby Simple
the project.. I have very clear instructions from my side.
Please feel free to contact directly, if any one is interested.
Hello Manhpham:
Please bid on the Project http://www.freelancer.com/projects/Java-database-administration/Java-JDBC-Connection-with-Derby.html
Project ID: 1435641
Sorry for the inconvenience since I had insert high budget. Please provide your bid on this one.
Budget: $ 40-$ 110 USD
Please feel free to contact directly, if any one is interested.
Hello Manhpham:
Please bid on the Project http://www.freelancer.com/projects/Java-database-administration/Java-JDBC-Connection-with-Derby.html
Project ID: 1435641
Sorry for the inconvenience since I had insert high budget. Please provide your bid on this one.
Budget: $ 40-$ 110 USD
Java, JDBC connection with Deby Simple
e 1 will provide a Category ID
- use table 1 category id to get table 2 content id
- use table 2 content id to get table 3 registration id
- use table 3 registration id to get table 4 uri_id
- use table 4 uri_id to get table 5 URI Object.
More information will be provided on awarding the project.. I have very clear instructions from my side.
Please feel free to contact directly, if any one is interested.
- use table 1 category id to get table 2 content id
- use table 2 content id to get table 3 registration id
- use table 3 registration id to get table 4 uri_id
- use table 4 uri_id to get table 5 URI Object.
More information will be provided on awarding the project.. I have very clear instructions from my side.
Please feel free to contact directly, if any one is interested.
Bingo game, server(java) + client (flash, actionscript)
e starts.
Every 5 seconds a random number is chosen by the server.
When this number is on your card, you scratch this number away. When your card is clean before the others, you win the prize, for example 100 points.
Then a new game can start, and everybody buys a new card.
Inspired by Sites:
http://www.poshbingo.co.uk/skin/play.php
http://www.bingolot.com
Every 5 seconds a random number is chosen by the server.
When this number is on your card, you scratch this number away. When your card is clean before the others, you win the prize, for example 100 points.
Then a new game can start, and everybody buys a new card.
Inspired by Sites:
http://www.poshbingo.co.uk/skin/play.php
http://www.bingolot.com
Problems with database connection on site
atabase connection on my site which is giving the error:
Access denied for user 'root'@'localhost' (using password: NO)'
PLEASE note that this is not due to the password field being empty.
The site does occasionally make a connection with the database and shows the results but rarely.
Apparently its due to a brute force attack on my db.
I need to get this error sorted out?
Bid if you know how this can be sorted.
Access denied for user 'root'@'localhost' (using password: NO)'
PLEASE note that this is not due to the password field being empty.
The site does occasionally make a connection with the database and shows the results but rarely.
Apparently its due to a brute force attack on my db.
I need to get this error sorted out?
Bid if you know how this can be sorted.
Php Expert With Mysql Database Knowledge 2
ttached breaking down each problem.
I need an Expert with high-level of understanding to fix these issues. The custom code has over 100,000 lines and has 7 levels of array. PMB me for discussion. Please read the attached document.
Additional Info (Added 4/18/2011 at 10:00 EST)...System Message: This is a reposting of project PHP Expert with MySQL Database Knowledge (1302723875).
I need an Expert with high-level of understanding to fix these issues. The custom code has over 100,000 lines and has 7 levels of array. PMB me for discussion. Please read the attached document.
Additional Info (Added 4/18/2011 at 10:00 EST)...System Message: This is a reposting of project PHP Expert with MySQL Database Knowledge (1302723875).
Php Expert With Mysql Database Knowledge
I have a custom php script with Mysql database and it has many bugs. I have found many things not working with the script. Some are minor and others require custom php/mysql programming skills since they are not complete. I have made a document attached breaking down each problem.
I need an Expert with high-level of understanding to fix these issues. The custom code has over 100,000 lines and has 7 levels of array. PMB me for discussion. Please read the attached document.
I need an Expert with high-level of understanding to fix these issues. The custom code has over 100,000 lines and has 7 levels of array. PMB me for discussion. Please read the attached document.
Java, Postgres DB, Spring Web Framework, Linux Server
r. Java Developer to support on existing incident tracking system. Java web application with PostgreSQL database running on Ubuntu Linux Servers.
Nice to also have Junit, Jasper Reports and JSON interface experience.
Immediate need is ~20 hours then monthly support ranges from 5-20 hrs / month.
System is an incident tracking system used in the Sport and Entertainment industry
Nice to also have Junit, Jasper Reports and JSON interface experience.
Immediate need is ~20 hours then monthly support ranges from 5-20 hrs / month.
System is an incident tracking system used in the Sport and Entertainment industry
Simple Database Needed
r an immediate turn around on this. I already have a large scale filemaker database created, but that is for my business and is not web based and is to advanced for what I am looking for here.
Additional work in connection with this database will be available at a furture date depending on speed and accuracy of this project whom ever it is awarded to.
If you have any questions or already have a similar database then please contact me.
Good Luck Bidding.
Additional work in connection with this database will be available at a furture date depending on speed and accuracy of this project whom ever it is awarded to.
If you have any questions or already have a similar database then please contact me.
Good Luck Bidding.
Simple CSS and Java script menu with a dynamic Active tab
="http://guide.advenquest.com/contactus.php">Contact Us</a></li>
</ul>
I need a script or some way make the menu tabs active when selected.
I really on need it on two links above:
www.advenquest.com and http://www.advenquest.com/modules/AMS/
The others are done via a third party site.
I tried a java script like"onclick="makeCurrent(this)" but can't seem to get it right.
</ul>
I need a script or some way make the menu tabs active when selected.
I really on need it on two links above:
www.advenquest.com and http://www.advenquest.com/modules/AMS/
The others are done via a third party site.
I tried a java script like"onclick="makeCurrent(this)" but can't seem to get it right.
Asterisk broadcast caller with webbased database
identify account from caller id
8a. plays welcome message prompts to cancel request or make changes
8b. if not canceled calls, texts, & emails contacts and tell them have message waiting
8c. prompts to repeat message or to conference in on original incoming call.
Changes Menu - The initial account changes option menu.
9a. enter pin
9b. change pin
9c. update your broadcast message
9d. update add or delete contacts
9e. close account
8a. plays welcome message prompts to cancel request or make changes
8b. if not canceled calls, texts, & emails contacts and tell them have message waiting
8c. prompts to repeat message or to conference in on original incoming call.
Changes Menu - The initial account changes option menu.
9a. enter pin
9b. change pin
9c. update your broadcast message
9d. update add or delete contacts
9e. close account
Java Learning
Can anyone give guidance on Java Programming? Connection to usual database also requested.
help me connect wordpress database wp-config.php
I need help with configuring my WordPress to establish a connection with my database.
WordPress is uploaded.
Database is created
WordPress is uploaded.
Database is created
Create a website with a database
have seperate login per member.
I need to be able to adjust the website myself.
But also I need to be able to change and add members in the database myself.
I have no knowlegde att all of websites.
The website will be a logistics website.
The website needs to be secured, so no one can copy any information.
I would appreciate a high google ranking.
I would like moving objects/pictures on the website.
I need to be able to adjust the website myself.
But also I need to be able to change and add members in the database myself.
I have no knowlegde att all of websites.
The website will be a logistics website.
The website needs to be secured, so no one can copy any information.
I would appreciate a high google ranking.
I would like moving objects/pictures on the website.
"make connection with precision engineering company"
Need to establish connection with precision engineering company. This is a prototype requirement, for companies specialising in the prototype manufacturer of high precision engineering parts.
PHP project with MySQL database and Smarty template engine.
ained and the candidate must master the required technologies in order to implement the required tasks. Also, it is very useful any prior experience with other websites of which the strong point is performance: we are interested in a direct simple queries and optimization, eliminating any code that's redundant and modularity.
More details on request
More details on request
website with a database required
I need a website with a database.
i have all the materials with me and want to complete it as soon as possible.
for detail message me
Php Expert With Mysql Database Knowledge
I have a custom php script with Mysql database and it has many bugs. I have found 7 things not working with the script. Some are minor and others require custom php/mysql programming skills. I have made a document attached breaking down each problem.
I need an Expert with high-level of understanding to fix these issues. The custom code has over 100,000 lines and has 7 levels of array. PMB me for discussion. Please read the attached document.
I need an Expert with high-level of understanding to fix these issues. The custom code has over 100,000 lines and has 7 levels of array. PMB me for discussion. Please read the attached document.
Conversion of Point of sale apps from C++/Access
e new database format should be MySQL. It should be possible to connect the application to an OSCommerce system for product stock level.
Delivery of the applications as sources.
I'm the owner of the current applications and can provide sources on request for reference.
A usermanual is available for reference.
I have no interest in ready made Point of Sales applications.
Delivery of the applications as sources.
I'm the owner of the current applications and can provide sources on request for reference.
A usermanual is available for reference.
I have no interest in ready made Point of Sales applications.
Simple Database Needed
se created, but that is for my business and is not web based and is to advanced for what I am looking for here.
Additional work in connection with this database will be available at a furture date depending on speed and accuracy of this project whom ever it is awarded to.
If you have any questions or already have a similar database then please contact me.
Good Luck Bidding.
Additional work in connection with this database will be available at a furture date depending on speed and accuracy of this project whom ever it is awarded to.
If you have any questions or already have a similar database then please contact me.
Good Luck Bidding.
Need html site converted to php with mysql database
I need my site converted from the existing html with css to a templated php site with mysql database.
Please pm me for website url.
Please pm me for website url.
